select count(*) as c FROM `tbl_properties` AS `SearchResult`,`tbl_properties_floorplans` AS `PropertiesFloorplan`
WHERE `PropertiesFloorplan`.`tbl_properties_id` = `SearchResult`.`id` AND (3958 * 3.1415926 * SQRT((`SearchResult`.`latitude` - 18.0666667) * (`SearchResult`.`latitude` - 18.0666667) + COS(`SearchResult`.`latitude` / 57.29578) * COS(18.0666667 / 57.29578) * (`SearchResult`.`longitude` - -77.2833333) * (`SearchResult`.`longitude` - -77.2833333)) / 180) <= 7 AND `SearchResult`.`looking` = 'N' AND `SearchResult`.`listing_type` ='res' AND `SearchResult`.`verify_status` = '1' Group By `PropertiesFloorplan`.`tbl_properties_id`
select count(*) as c FROM `tbl_properties` AS `SearchResult`,`tbl_properties_floorplans` AS `PropertiesFloorplan`
WHERE `PropertiesFloorplan`.`tbl_properties_id` = `SearchResult`.`id` AND `SearchResult`.`mls`='mls' AND (3958 * 3.1415926 * SQRT((`SearchResult`.`latitude` - 18.0666667) * (`SearchResult`.`latitude` - 18.0666667) + COS(`SearchResult`.`latitude` / 57.29578) * COS(18.0666667 / 57.29578) * (`SearchResult`.`longitude` - -77.2833333) * (`SearchResult`.`longitude` - -77.2833333)) / 180) <= 7 AND `SearchResult`.`looking` = 'N' AND `SearchResult`.`listing_type` ='res' AND `SearchResult`.`verify_status` = '1' Group By `PropertiesFloorplan`.`tbl_properties_id`
not mls===2==mls===0
SELECT `SearchResult`.`id`,
round((3958*3.1415926*sqrt((`SearchResult`.`latitude`-18.0666667)*(`SearchResult`.`latitude`-18.0666667) +cos(`SearchResult`.`latitude`/57.29578)*cos(18.0666667/57.29578)*(`SearchResult`.`longitude`--77.2833333)*(`SearchResult`.`longitude`--77.2833333))/180),1) as distance,
`SearchResult`.`external_source_ID`,
`SearchResult`.`feed_type`, `SearchResult`.`owner_screenname`, `SearchResult`.
`headline`, `SearchResult`.`address1`, `SearchResult`.`city`, `SearchResult`.`state_full`,
`SearchResult`.`country`, `SearchResult`.`latitude`, `SearchResult`.`longitude`,
`SearchResult`.`display_address`,`SearchResult`.`build_year`,`SearchResult`.`listing_type`,
`SearchResult`.`looking`,`SearchResult`.`mls`,`SearchResult`.`property_description`,
`SearchResult`.`property_type`,`SearchResult`.`primary_photo`,
`SearchResult`.`primary_photo_thumbnail`,`SearchResult`.`num_paid_photos`,
`SearchResult`.`created`,`SearchResult`.`incentive`,`SearchResult`.`currency_code`,
`SearchResult`.`is_fix_rate`,`SearchResult`.`is_featured`,`SearchResult`.`final_incentive`,
`SearchResult`.`idx_county`, `SearchResult`.`idx_style`, `SearchResult`.`idx_garage`,
`SearchResult`.`range_bd_room`, `SearchResult`.`range_bt_room`, `SearchResult`.`range_rent`,
`SearchResult`.`range_floor_area`, `SearchResult`.`mls_logo_image`,`PropertiesFloorplan`.`floorplan_desc`,
`PropertiesFloorplan`.`apt_mul_plan`
FROM `tbl_properties` AS `SearchResult`,`tbl_properties_floorplans` AS `PropertiesFloorplan`
WHERE `PropertiesFloorplan`.`tbl_properties_id` = `SearchResult`.`id` AND `SearchResult`.`mls`!='mls' AND (3958 * 3.1415926 * SQRT((`SearchResult`.`latitude` - 18.0666667) * (`SearchResult`.`latitude` - 18.0666667) + COS(`SearchResult`.`latitude` / 57.29578) * COS(18.0666667 / 57.29578) * (`SearchResult`.`longitude` - -77.2833333) * (`SearchResult`.`longitude` - -77.2833333)) / 180) <= 7 AND `SearchResult`.`looking` = 'N' AND `SearchResult`.`listing_type` ='res' AND `SearchResult`.`verify_status` = '1' Group By `PropertiesFloorplan`.`tbl_properties_id` Order By SearchResult.final_incentive desc limit 0, 16
Mwendo - Residential Sale - Alexandria, Clarendon
Mwendo provides an open platform
to display real estate (residential and commercial), apartment, roommate,
sublet, and vacation home listings whereby the Offerer may provide cash
rewards to potential tenants and homebuyers.
Loading .... 
Compare 